excel 表格里既有文本又有数字 计算只计算数字答:B1公式下拉:=IF(A1="","",SUMPRODUCT(--TEXT(MID(TEXT(MID(SUBSTITUTE("元"&A1,"+",REPT(" ",9)),ROW($1:$300),10),),2,9),"0.00;-0.00;;!0")))
求excel表格提取特别指定数字组合的公式答:H2单元格公式:=IF(AND(SMALL(C2:G2,1)=SMALL(C2:G2,2)-1,SMALL(C2:G2,2)=SMALL(C2:G2,3)-1,SMALL(C2:G2,3)=SMALL(C2:G2,4)-1,SMALL(C2:G2,4)=SMALL(C2:G2,5)-1),SMALL(C2:G2,1)&SMALL(C2:G2,2)&SMALL(C2:G2,3)&SMALL(C2:G2,4)&SMALL(C2:G2,5),"")...